Parameter Query to Search Multiple Fields

[Parariddle]

Hi All

I have a query which I want to use as the basis for a report to bring back information on reports due on a certain day.

I want to create a parameter query to search 31 columns to find the dates linked to the reports.

What is the best way of going about this ?

Thanks !

 

[KenHigg]

'31' - Sounds like you need to normalize something.

 

[MSAccessRookie]

Hi All

I have a query which I want to use as the basis for a report to bring back information on reports due on a certain day.

I want to create a parameter query to search 31 columns to find the dates linked to the reports.

What is the best way of going about this ?

Thanks !

Would it be possible for you to show the following:

• The structure of the table (no data required).
• The SQL that you are trying to use.

I sense an unfriendly (non-normalized) Table structure here. If you have 31 columns with dates (One for each day of the month, I presume), then normalizing it to have an additional table of dates might make the job much easier.

 

[Parariddle]

I am trying to create a log to show when reports are due.

I have set up a form for managers to fill in and then imported that into access. What I am trying to do is plan for a whole year the reports that are due. So in the first 5 columns I have report information etc then 31 columns with dates in the cells to show the date the report is due that month. My problem lies in that the reports can be monthly, daily, qtrly etc so i am trying to keep it as simple as possible.

So my query was looking across 31 columns so my manager can enter a date to bring back a list of reports due on that day.

Hope that makes sense and gives you a better idea of what I am trying to achieve.

 

[MSAccessRookie]

I am trying to create a log to show when reports are due.

I have set up a form for managers to fill in and then imported that into access. What I am trying to do is plan for a whole year the reports that are due. So in the first 5 columns I have report information etc then 31 columns with dates in the cells to show the date the report is due that month. My problem lies in that the reports can be monthly, daily, qtrly etc so i am trying to keep it as simple as possible.

So my query was looking across 31 columns so my manager can enter a date to bring back a list of reports due on that day.

Hope that makes sense and gives you a better idea of what I am trying to achieve.

It sounds a lot like you are creating an Excel Spreadsheet as opposed to an Access Database. While the Forms and Reports in your project can look like (or even be converted to) an Excel Spreadsheet, the information itself is best not to be stored that way.

Show us the Table Structure(s) and perhaps we can assist you in finding another way to do what you are looking for.

 

[Parariddle]

Thanks for the help

I have only just started and your probably right as I am trying to get access to do what some other software can do and report from a data source.

Ok well the table structure is

PrimKey
Report ID
Report
Frequency
Team
Report Location
Procedure Location
Month
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

Its not pretty but as I mentioned for all involved I am trying to keep it simple.

 

[Parariddle]

Having regained my brain and asked a colleague I have used the or function in access.

However I would love some advice on making the database the best it can be. I will post in another section to get some answers on how to achieve this.