I have to have the data transfered automatically in the fields. 1. Data in Field A= data in Field B* data in Field C/ 100.How to do this in the "Forms"? 2....

For something like "10 and =20" how do I create an IIF statement?

Hi, I actually copied over the database of previous yr to tis yr. So as i want to enter the data, the autonumber continues from the previous database. So...

Salve a tutti, qualcuno ha qualche idea su come eseguire una query e ordinare il risultato per il giorno? Mi spiego meglio: Ho una tabella contenente i giorni...

Hi maurizio, I think your query will be a bit more complex. It will have to look something like: Select StudentID from STUDENTS where StudentID IN (Select...

I am trying to group time information by year. I have a field containting seconds and have figured out how to show hours and minutes in the query but cannot...

Hello: On a form: Trying to display results of a query in a listbox. Textbox | Button | Listbox The textbox takes the criteria for a query. The button...

This is the current SQL query I have. It only displays Saturday and not Sunday. I need it to display both (SATURDAY and SUNDAY). SELECT format(date_1,...

I have a medical database containing (amongst others) a history of injury field (text), body region and attending dates. I have the following query that...

Hi, i am missing data in some of my reports. I check my queries and some of them have 1 in the criteria of some of the fields ie: (fldDate orautoNo)

I have created Kanban cards with the part number and card number in the barcode. I need to break down the data without going to excel and reloading back to...

Attention: If you are reading this, please respond, and accept my apology for being rediculous and immature. I posted a message while I was intoxicated and...

Hi Folks, I need to create a query that I can use to create a chart from within Access. I create monthly reports that show a 12 month snapshot of our...

I have three fields in the detail section and only the second field shows data. The other two do not. How come it will show in a table or a query but not in...

I need to produce reports for records falling within the 7 day range of each week. I have queries written where I am promted for a start and finish date...

I have 3 subforms linked to 3 tables, they are driven by 3 seperate queries. When I try to update them from the open master form with a command button, i get...

I have an Access table with a Yes/No field called Active. If Active is True for all records, SELECT Active FROM ATHLETE ORDER BY Active; Returns...

I have an issues with my Microsft Access Database. It's an infentory database, storing all the information about our hardware here at the store. The files...

Hi all, I'm stuck trying to figure out how I can pull an employee's training history for the current and prior year. The year is based on their hire date....

I have designed a query where i want to sum how many quotes have been either sent, not sent or rejected by country. I have used this as my SQL but it brings...