I currently have C++ code that processes a raw data file containing multiple types of records. The code creates records in multiple tables in an Access...

I'm having trouble with a query I'm working on. I am running it with multiple criteria and it works perfectly fine. However, when I change the "Total" row...

given: weeknumber and year I want to know : the date of the sunday (1st day of week) of the given weeknumber the date of the saturday (7th day of week) of the...

I'm trying to run the following append query. The table Carroll contains 238 records. Each time I run the query it's appending a different number of...

I have a query in which I want to search records by a network user name. Can anyone help with what would go in in the criteria area? If my network ID...

I need to query the max of strRVSP that is also 40 (this is because there could be multiple values 40) and also have the corresponding date. I tried to do...

-- Wendy

I have a table called PT tbl. If a client has a status of Unacceptable (a field in the table) for two out of the three most recent dates (PT Date field), I...

One part of my database is used to keep track of contacts within clients. I created a query using a table and a crosstab query and exported it to excel. I...

I have a database that has 1 record per each item. I want to combine these and only list the total. I have the following SQL statement. SELECT DISTINCT...

Good Afternoon, I would like to thank you in advance for taking the time to try and help me with my request. I have posed a similar question about a month...

I just ran a query and MS Access shows it is un updatable query. I just wonder are there any query is updatable? If yes, are there any rules that for...

I need some conceptual help please. My end result is that I want to set-up criteria in a form that will do comparisons for month to month, this year’s...

Hi Folks! I'm trying to put together a string with two fields - and , both text fields, the "landline" is an unformatted phone number. Using =( & ", " &...

I have the following fields I'm working with; they are all on the same Form which comes from a query. MultiClassDisc TotalTuitions TotalTuitions is...

I noticed that this query shows records the records between even if the second date is larger than the first. No big deal really I just was not expecting...

I would like to combine two iif together. I am able to get the results from a single iif statement but not successful in combining the two. iif(!Verbiage...

Hello, I need to take a currency field and store it as text but keep the commas. Anyone know the syntax for this. Sample text would be 3,54,998.98 Thanks

Hello Everyone, I have a table which has about 150 fields (columns). About 140 fields contain numbers. Note: This is not a normalized table as the data...