Search results

my query has a criteria where the key field is not null, so there are no null records (or at least there shouldn't be). Maybe it would be easier for you to review the access program (I've attached it). The query is " CreateCompareExport".

Thank you for your reply! I'm creating a table when I then have Access export to a spreadsheet. Before the query runs, I delete the former copy of the table, that is created by my query. The query merges data from multiple and creates a new table of the merged data. VBA that runs...

Thank you for your response! The table that I create is doesn't already exist - so I can't understand when it creates a new table, why it would matter what the data type is? I'm not trying to update an existing table, where i can understand if there would be incompatible types. My...

Hello, I'm currently stumped and am hoping someone can help me. I have a query with 38 fields which I pull together data to Create a Table. When I put the query into Select mode, it runs fine with no errors, but when I switch it to Make Table mode, I get the following error (see attachment...

I have a data entry form I set up in Access. It is a continuous form, and has a footer which accumulates field totals. I set up my totals with the =sum([fieldname]) in the Control Source property and it was working, but for some odd reason it stopped working and all I get now are #Errors. I've...

Micron, thank you so much for the prompt reply. Maybe it will help if I list the table for the time entry and a separate table for the Time Summary. Think as if I'm entering time that an employee worked for 1 week: 32 hours regular time 8 hours vacation, 2 hours overtime. The time entry...

Hi, I have a time card data entry form which is based on a query. On the same row of the continuous form I have created several unbound fields which I want to calculate values based on other fields' data. I plan to then use total calculation fields in the footer to display totals. I...