Hello to all... I have read in another helpful post that the Access JET SQL engine does not provide for the above syntax when desiring a count of records in a...

I am trying to export records based on a query. DoCmd.TransferSpreadsheet acExport, , "Query", "C:\test.xls", True The Query "query" works fine but it does...

I would like to set up a query by entering specific event,and by specific month that how would i write this under criteria?

Interesting thing happening. Created a flat database in AccessXP (patched as of 6/26/04). Have a field labeled description with the property of memo. The...

Hi, I am struggling with queries or crosstab but it seem that it doesn't work. I have a table that show: Category NameCode Name ...

I have a table with a sequence of dates, some dates are duplicated. I also have a query that lists "appointments" from another table. I need to create a new...

Is there a way in SQL or VBA to change the data type of a link field prior to running any time of query? Someone thought this might be the best way to handle...

Is it possible to make a TRANSFORM query with alphanumeric data???

I want to return different values from a field in a table to multiple fields in a query. ie. the table field has "Incoming", "Outgoing"... in its data and...

I'm sure there's a simple answer to this question. I'm new to Access. I have 2 tables, each with a column titled "Company Name." I would like to use a query...

Can anyone point me to a general information site. I simply want to generate queries (or reports) that sum columns for sub-totals and totals. The standard...

Hi, I have a querry field which is store some date value like this format "month&day" 0427 0428 0429 0430 0501 0502

I created a query with a circular reference. Everytime I try to enter the Design view (or run the query) to correct the problem, MS Access shuts down. Is...

i have a crosstab query and i want this query to show the data what i have selected in the form,it is possible or is there any way to do this? 'coz i cant run...

Is their away to reset the Auto number back to one? Every Time I run the query I need the table to delete and repopulate with new data and the the first entry...

I am trying to create a query to search a Book Category field in a Books table. The database is not normalized so the different book categories aren't stored...

Hello, I get data provided that I need to query out some records. The field to query is a text field and has names in it, ie: Bob Smith Jane Doe Rodney...

I am migrating from Access 2000 to SQL Server. Please help with my Access Query which I am translating into T-SQL for a SQL Server Stored Procedure. I am...

The following query gives the error: "Operation must use an updatable query" What is wrong here? UPDATE PartNumbers a Set Width =(Select Width from...

I have code that runs various queries. The only two I have a problem with are the two that use select queries as input. When each runs, the results of...