I am going round in circles with this and would be grateful for any help offered. It may be a case that I am missing something quite simple but phrase wood...

My cross tab query results are not listing the months in chronological order. Also I wold like a total for each month of all types, I have a total by type...

Hi I have three field in the Query: A B and C. The table is as low A B C D 1 2 3 3 2 2 1 2 3 1 1 3 I want an...

I'm having trouble with this one, I have some raw data in a table that I successfully formatted to be (in a query), for sake of discussion, a start date, a...

I am already pretty frustrated with so much to tinker with OL2007. A year ago I loaded OL2007 to my laptop and migrated all the info from my previouse...

There one has me bumfuzzled!!!!! this is a rental program. I have two fields "admission date' and "discharge date" for each patient that rents a unit. I want...

I try to delete agent (1 side) that has no matching record in master (many side) but it would not allow me to do so. I can select, but not delete. Here is my...

not sure if the subject explains the process but.... I have a Membership Table that holds a people ID field that relates to the People Table where I hold...

All Need a little more help. I have the following in a field to determine what date to drive the computation from. It is not working correctly...

I have a query that results in numerous waste codes for a specific profile. However, I get duplicates of the profile for each waste code. I need this...

Can someone help me with this, I am drawing a blank this morning? BACKGROUND: My predecessor had a very simple (yet powerful "delete *") query set to act...

I'm using a form for the user to input a part number exactly as it is. ex. #7-7 I then have a query that runs based on the value entered on the form. It...

I want to create a field to return the revenue variance of 2 months (ie, May v June) when all months are contained in one single field "Fiscal Period"

concatenate("SELECT accomp & SIM2 FROM R010SIMTABLE WHERE ssan=""" & & """") I would like to add another linked field from r010simtable where shortid =...

I have been running a query which links 3 Tables. The data has been updateable. When I add a 4th table the data is no longer updateable. Main Table:...

I have a query run from a master table. It looks great in print preview but when I print it sometimes fields overlap or have spaces that I didn't put there....

I have created a series of calculated fields in a query that I want the values to approximate to 2 decimal places when calculating but the program pick the...

I need to generate a number in second from midnight. Example the reporting time is 7:50 AM , 84600 second in the day minus 28500 (Start Time in Seconds) =58200...

I have a query that calculates a shift number by looking at the start time of an event: shift: IIf(DateDiff("h",#12:00:00 AM#,) Between 7 And...

I am trying to sum the fldHC, but it takes the field Planned as a separate number and gives me 2 records and does not sum them. I just can not see what I am...