Hi, I am trying to sort some data in a report. What I am trying to do is for exemple, I have these datas: 10056, 10048, 10071, 10025 I want to sort in...

In my database's Main table I have a field that is alpha-numeric (i.e. CB-01-1101-09-07) The number is NOT assigned to every row, only a select number of...

I am trying to create a list of top 100 customers by spending for each store. I can successfully create the list of top 100 customers for all stores, but when...

I am stumped. Please help me! I need help with syntax for an expression. I have a simple table which contains one column for each date of a particular...

Hi All I am looking for some guidance if someone would be so kind as to indulge with me for a moment. I am trying to create a Db to record Job cards, Work...

I am looking at Allen Browne's audit log at: http://allenbrowne.com/AppAudit.html and wanted some advice to ensure this is the right way for me to go to...

i need help on my download scam site the who is dns server is not working with my php database. can anyone help? you can email me directly or use this...

This is my problem: I manage a ball database which includes 6 different cell locations in a ball bearing plant. I'm trying to create a query in Access 2000...

I am a very sporadic Access user and could use some guidance for a new task. I have an existing Access DB I am using to report on parts we have ordered. There...

I need a report that shows the payments of an amortization database. I want the query to show all payments for each year up until the loan is paid (principal...

Hi there, Which is more efficient from a programmer and program performance stand point. Creatinga query and using it as the recordsource, or creating a...

Errors about Format(), Right(), Left() functions started when I took reports and querys made in Access2000 and applied SP3 environment. Is this a dll or...

I'm using an Access 2000 database, and another mdb file, where I'ev got froms, scripts and queries. I've made changes (using Access 2002) on the table database...

-- the8thdove

I have this query that works fine for everyday of the week except Saturday going into Sunday...What it does is pop-up a form with a listbox containing menu...

error window says "Microsoft Access couldn't find file 'system.mdw' This is required for startup." I insert MS Office 2000 SR1 to let it look for...

I have a table that is in the correct format. When I run a append query against this table the format is off, there is a number where there should be text....

After scanning a text document using MS Office Document Imaging, it goes through the OCR process, but the image is not available. Up until 3-4 days ago, it was...

I have created an Unmatched Quiz for two tables - tbl_WRFNSR Curr Month and tbl_WRFNSR Prior Months. My objective is once this query is done, I'd like to get...