Search results
-
H
Exclude when the current month EXCEPT when?
Does anyone know how to INCLUDE the month of May or June data when the current month is May and if the current month is June but all other months exclude the "current" month? I'm working with <>Month(Date()) to exclude current month, however I need ALL months when the current month is May... -
H
Button not working on one user station?
Command Button not working on one user station? Hello, I can't figure this problem out ... one user is using runtime MS Access 2000 and have been able to use this form with an OK command button to launch a report before but now she is unable to do so. I can't duplicate the message as it's...- helpangel
- Thread
- Replies: 2
- Forum: Modules & VBA
-
H
Fix SQL statement, returning error ...
Hello, Run-time error ... No value given one or more required paramete UPDATE GuitarOptionDetails SET GuitarOptionDetails.OptionCombo = Concatenate("SELECT Option_Item FROM GuitarHeader WHERE GuitarItem & Option_Item =""" & [GuitarOptionDetails].[GuitarItem] &... -
H
Complex query??
Hello everyone! i hope someone can help me with either: 1. writing a query to get the results needed (will explain below) 2. write VBA to be used in query to get the results needed 3. or change table(s) to be able to obtain the data in all areas to get the results needed. The result needed...