I want to create a new table with a query that will sum one field entry if 4 field entries all match to generate one entry in the new table from query...

I'm running Win2k SP-4, MS Access 2000 SP-3, and JET 4.0 SP-8. While working on a question posted earlier, Access gave me results I couldn't figure out. I...

if i "nest" switchboards that I have access to create, is there a way change the appearance on each of them or will they all have to look the same? Also, is...

I'm trying to get three buckets of users based on their variation in number of transactions between two years. I get an error message stating "Syntax Error...

I just had MS Office 2003 installed on my computer at work. I previously had Office 2000. I am always copying query results and pasting them into Excel. This...

Hi, I've been designing a database that basically works off two tables. From the first table, I have a query that pulls information and populates the second...

I have two tables that contain similar information, but a different list of names. I need to combine the two tables so that each name appears, and...

If I create a query in an Access Project, (with the datasource in SQL 2000), and I prompt for a time range, (start and end time), it returns zero rows. If,...

Hi, I would like to study of how to make an easy user interface via Net to Access database. Please give your recommendation. Matti

I Have a form that has a button that when clicked it sends data from a query that i have to a excel spreadsheet. the problem that i am having is when i run it...

I realize that this question is not strictly "on-topic" w/r/t this NG; however, it directly affects participation in this group. Several of the larger...

When I choose File - Get External Data - Import and choose ODBC it gives me about 1000 tables to choose (maybe) but I need access to any and all 20,000 that...

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...

I've got Access2002 with SQL-server tables linked in. The field is appearing as date/time in Access, but if I put #06:45:00#, say as a criteria, or use the ...

I am using access 2007. I don't know if that makes a difference or not. If I want to output an access query to a text file, it is putting like a "printed...

Am trying to put largish charity DB on web with a find facility for each individual charity, so far with notable lack of success. Can anyone point me in the...

Hello- I am experiencing a weird problem. The database has been functional for 4 years. Now one of the total queries is spewing garbage characters???? The...

Hi, I'm trying to port the following to access (run through OLEDB) and I keep getting an error stating "Syntax error (missing operator) in...

Is anyone aware of a system variable that holds the number of updates done after an update query? The number displays, so it must be someplace! Another...

I need to convert this SQL statement to a statement that Access 2003 will run. Any suggestions? I have two tables. GL_ALL contains all imported records with...