How to unconcatenate a record in Access 2 432 (6/25/2007 4:46:05 PM)
I have a table with a fields that contains both a date and time. I am having trouble pulling a query using a Between (this) And (That) criteria. Can I do something like I can in Excel where I can seperate t...
Utf

Field Contains 2 134 (6/26/2007 2:40:00 PM)
How can I query [Comments] and and return all of the record that contain the work "retired" or "Retired"? Thanks! ...
Utf

Contains Word 2 117 (6/26/2007 2:41:00 PM)
How can I query [Comments] and return all of the records that contain "retired" or "Retired"? Thanks! ...
Utf

Autonumber 3 107 (6/25/2007 7:53:01 PM)
Hi I have to create a "Certificate" report which will have a unique numeric reference for each "Certificate" generated. I have created a select query that pulls the various pieces of data needed to form the...
Utf

How do I display 1 line per Invoice Summary w/totals from Invoice Detail ? 4 527 (6/25/2007 7:05:50 PM)
I enter Invoice Summary and Invoice Detail information via a Form/ Subform . The Invoice Summary contains only Customer Number, Date, and Invoice Number. The Quantity, Unit Price and Tax information is stored...
mthornblad

Help with time formatting.Please! 5 111 (6/25/2007 1:16:43 AM)
Is there a way to set a time field default (in table) to Now() and have it round to the nearest hour? -- Pat "If you can find a path with no obstacles, it probably doesn't lead anywhere" ...
Dupatt

Crosstab query 3 154 (6/22/2007 8:23:01 PM)
Hi, All I have a table with following fields: IssDate IssTime Tick Badge Locat Viol 6/18/07 15:30 102003 999 MAIN 141 6/19/07 16:30 102023 999 MAIN ...
Utf

A better way to look for 'A' thru 'M'? 5 89 (6/25/2007 6:31:02 PM)
Hello, I have the following query: SO CA: IIf([All Programs Quoted crosstab].[State]="CA" And [All Programs Quoted crosstab].[Zip_Code]<"94000" And ([All Programs Quoted crosstab].[Broker_Name] Like "a*" Or...
Utf

Count Across Columns 2 188 (6/22/2007 8:14:12 PM)
In a query,m I have selected four fields plus the id field from a table of 50. Each of the records are marked with an X or not. ID 2000 2002 2004 2006 Count ? 1 x ...
Craig

Stacked crosstab query - dynamically update columns 6 187 (5/28/2007 11:46:15 PM)
I have a crosstab query that compiles data for Months of the year. I have a stacked select query on top of that crosstab query that uses the latest 2 months data and exports it to a fixed length flat file. Idea...
m